prepare("select * from staff_table where (staff_id_no =:a or phone_no =:b)") ;
$check->bindparam(":a",$staff) ;
$check->bindparam(":b",$staff) ;
$check->execute() ;
if($check->rowcount() > 0)
{
$insert = $DBcon->prepare("insert into attendance(staff_id,checkin_time,cdate,checkout_time) values(:as,NOW(),NOW(),'')") ;
$insert->bindparam(":as",$staff);
if($insert->execute()) $msg = "Check In Successfully" ;
}
else
{
$msg = "The Staff you enetered is not Registered in this system" ;
}
}
?>
Admin Panel
